Printing a Sales Rep Invoice Cost Register

Once you have entered all of the required information needed to generate a Sales Rep Invoice Cost Register, command options will appear allowing you to print or choose from a set of other print options.

The Sales Rep Invoice Cost Register allows you to print an analysis of all sales orders invoiced by a sales rep (or multiple sales reps) within a given time frame. The register provides pricing and costing information, and lists gross profit and margin information.

The following prints on the Sales Rep Invoice Cost Register in detail for each invoice sorted by date and customer:

• Cust – The customer ID code
• Inv # – The invoice number
• Ship Date – The date the order was shipped
• Invoice Date – The date the order was invoiced
• Item – The item(s) invoiced
• Order – The sales order number
• Amount Invoiced – The total extended product price charged for all items invoiced
• Amount Invoiced (Other) – The total extended other price charged for all items invoiced
• Amount Invoiced (Total) – The total dollar amount invoiced; Product (the amount of product invoiced) plus Other (non-product items invoiced)
• Cost – The total extended product cost attributed to the item

• Gross Profit – The total dollar amount of profit based on the Margin Calculation Formula setting in Ledger Options
• Margin % – The gross profit expressed as a percentage of the total amount invoiced based on the Margin Calculation Formula setting in Ledger Options
• Grand Total – The grand total for each of the columns (headers) listed on the report.

Uncosted Items Page

Items that have been invoiced but have not yet been costed are itemized at the end of the report in a separate uncosted item report for customers above and below the line.

• SP – Sales rep
• Broker – The broker ID, if you have selected Y (Y=yes) in the Broker field
• Customer – The customer ID code and name of the customer
• Item – The item group and item name
• Order – The sales order number
• Invoice – The invoice number if the order is invoiced
• Quantity – The quantity of the item shipped to the customer
• IN UN – The invoicing unit of measure
• Selling Price – The total per unit selling price of the item
• Extended – The dollar amount charged for the item. Quantity multiplied by Selling Price = Extended.

Note: A list of uncosted items will appear if uncosted items exist.

For more information on the Sales Rep Invoice Cost Register option see Sales Rep Invoice Cost Register.

Security Required : System - Profit Margin